﻿create procedure [dbo].[usp_Get_EmployeeLeaves_For_Team]
@TeamId as int 
as
select * from TblEmployeeLeaves where EmpId in
(select EmpId from TblTeamMembers where TeamId = @TeamId)